SQL: Comprehensive Beginners Guide to SQL Programming with Exercises and Case Studies by Paige Jacobs

Author:Paige Jacobs [Jacobs, Paige]
Language: eng
Format: azw3
Published: 2018-12-25T16:00:00+00:00

In simple words, it is never a good idea to let someone else define the constraints for your database since this will introduce a security breach. This also means that the user may sometimes get in your way.

Delegating Responsibility

If you want to maintain a secure system, you should restrict the access privilege that you grant to different users. You should also decide which users can access the data. Some people will need to access the data in the database to carry on with their work. If you do not give them the necessary access, they will constantly badger you and ask you to give them some information. Therefore, you should decide how you want to maintain the database security. You can use the WITH GRANT OPTION clause to manage database security. Let us consider the following examples:

GRANT UPDATE

ON RETAIL_PRICE_LIST

TO SALES_MANAGER WITH GRANT OPTION

The statement is similar to the GRANT UPDATE statement that allows the sales manager to update the retail price list. This statement also gives the manager the right to grant any update privileges to people she trusts. If you use this version of the GRANT statement, you should trust the fact that the grantee will use the privilege wisely. You should also trust the fact that the grantee will grant the privilege to only the necessary people.

GRANT ALL PRIVILEGES

ON FOUR_STAR

TO BENEDICT_ARNOLD WITH GRANT OPTION;

You have to be careful when you use statements like the one above. If you misspell the name or give the wrong person access, you cannot guarantee the security of your database.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.